/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.TransfersBO;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class TransfersExportDAO
/*    */   implements IExportAll
/*    */ {
/* 18 */   private static final Log log = LogFactory.getLog(TransfersExportDAO.class);
/*    */ 
/* 20 */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime) { ResultSet rs = null;
/* 21 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 24 */       String strSQL = " select * from transfers where  btsname like '%" + strBtsName + "%' ";
/* 25 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 26 */       log.info(strSQL);
/* 27 */       rs = dbcon.execQuery(strSQL);
/* 28 */       while (rs.next()) {
/* 29 */         TransfersBO bo = new TransfersBO();
/* 30 */         bo.setId(rs.getString("id"));
/* 31 */         bo.setBtscode(rs.getString("btscode"));
/* 32 */         bo.setBtsname(rs.getString("btsname"));
/* 33 */         bo.setTransAF(rs.getString("transAF"));
/* 34 */         bo.setSDHAF(rs.getString("SDHAF"));
/* 35 */         bo.setPDHAF(rs.getString("PDHAF"));
/* 36 */         bo.setMicrowaveAF(rs.getString("microwaveAF"));
/* 37 */         bo.setOtherAF(rs.getString("otherAF"));
/* 38 */         bo.setSDHAM(rs.getString("SDHAM"));
/* 39 */         bo.setPDHAM(rs.getString("PDHAM"));
/* 40 */         bo.setMicrowaveAM(rs.getString("microwaveAM"));
/* 41 */         bo.setOtherAM(rs.getString("otherAM"));
/* 42 */         bo.setVoltageA(rs.getString("voltageA"));
/* 43 */         bo.setPropertyA(rs.getString("propertyA"));
/* 44 */         bo.setOpentimeA(rs.getDate("opentimeA"));
/* 45 */         bo.setDistODFAF(rs.getString("distODFAF"));
/* 46 */         bo.setDistDDFAF(rs.getString("distDDFAF"));
/* 47 */         bo.setDistcomtankAF(rs.getString("distcomtankAF"));
/* 48 */         bo.setDistotherAF(rs.getString("distotherAF"));
/* 49 */         bo.setDistODFAM(rs.getString("distODFAM"));
/* 50 */         bo.setDistDDFAM(rs.getString("distDDFAM"));
/* 51 */         bo.setDistcomtankAM(rs.getString("distcomtankAM"));
/* 52 */         bo.setDistotherAM(rs.getString("distotherAM"));
/* 53 */         bo.setEle2MCNum(rs.getString("ele2MCNum"));
/* 54 */         bo.setEle2MUNum(rs.getString("ele2MUNum"));
/* 55 */         bo.setEle2MAUNum(rs.getString("ele2MAUNum"));
/* 56 */         bo.setEle2MUidx(rs.getString("ele2MUidx"));
/* 57 */         bo.setEle2MUTimeSlot(rs.getString("ele2MUTimeSlot"));
/* 58 */         bo.setMaintenance(rs.getString("maintenance"));
/* 59 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 60 */         bo.setMemo(rs.getString("memo"));
/* 61 */         bo.setStr2MUseSta(rs.getString("2MUseSta"));
/* 62 */         bo.setIsPowerAlone(rs.getString("isPowerAlone"));
/* 63 */         bo.setMemo(rs.getString("memo"));
/* 64 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 68 */       e.printStackTrace();
/* 69 */       log.error(e.getMessage());
/*    */     }
/* 71 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.TransfersExportDAO
 * JD-Core Version:    0.6.2
 */